[dbo].[Donation

Property	Value
Heap
Row Count	0
Created	3:12:09 PM Friday, January 07, 2011
Last Modified	3:12:09 PM Friday, January 07, 2011

Property

Value

Heap

Row Count

Created

3:12:09 PM Friday, January 07, 2011

Last Modified

3:12:09 PM Friday, January 07, 2011

Name	Data Type	Max Length (Bytes)
ORIG_TRANS_NUMBER	int	4
DONOR_ID	varchar(10)	10
PRODUCT_CODE	varchar(31)	31
QUANTITY	int	4
ORDER_NUMBER	float	8
TIME_STAMP	timestamp	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

ORIG_TRANS_NUMBER

int

DONOR_ID

varchar(10)

PRODUCT_CODE

varchar(31)

QUANTITY

int

ORDER_NUMBER

float

TIME_STAMP

timestamp

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

Type

Action

Owning Principal

Grant

Delete

IMIS

Grant

Insert

IMIS

Grant

References

IMIS

Grant

Select

IMIS

Grant

Update

IMIS

SQL Script

CREATE TABLE [dbo].[Donation_Premium]
(
[ORIG_TRANS_NUMBER] [int] NULL,
[DONOR_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QUANTITY] [int] NULL,
[ORDER_NUMBER] [float] NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
GRANT REFERENCES ON  [dbo].[Donation_Premium] TO [IMIS]
GRANT SELECT ON  [dbo].[Donation_Premium] TO [IMIS]
GRANT INSERT ON  [dbo].[Donation_Premium] TO [IMIS]
GRANT DELETE ON  [dbo].[Donation_Premium] TO [IMIS]
GRANT UPDATE ON  [dbo].[Donation_Premium] TO [IMIS]
GO